DECLARE @DateFrom Date

DECLARE @DateTo Date

SET @DateFrom = '2008-01-01'

SET @DateTo = '2015-06-30'
SELECT Name, Path, UserName

FROM Catalog INNER JOIN dbo.Users ON Catalog.CreatedByID = Users.UserID

WHERE Type = 2 AND

    Catalog.ItemID NOT IN

    (

        SELECT ExecutionLog.ReportID

        FROM ExecutionLog

         WHERE ExecutionLog.TimeStart BETWEEN @DateFrom AND @DateTo

    )

    ORDER BY Name